﻿using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Security.Cryptography;
using System.Configuration;
using System.IO;

namespace CashNote
{
    public partial class MenuTestForm : Form
    {
        public MenuTestForm()
        {
            InitializeComponent();
        }

        private void contextMenuStrip1_Opening(object sender, CancelEventArgs e)
        {

        }

        private void contextMenuStrip1_Click(object sender, EventArgs e)
        {

        }

        private void MenuTestForm_Load(object sender, EventArgs e)
        {
            StringBuilder sb = new StringBuilder();

            sb.Append(" SELECT   c.menu_id, c.up_menu_id, c.menu_name, c.status, c.flag, c.menu_string ");
            sb.Append(" FROM      (((sys_right a INNER JOIN ");
            sb.Append("                 sys_staff b ON a.right_id = b.right_id) INNER JOIN ");
            sb.Append("                 sys_staff_menu d ON a.right_id = d.right_id) INNER JOIN ");
            sb.Append("                 t_menu c ON d.menu_id = c.menu_id) ");
            sb.Append(" WHERE   (b.staff_id = 'admin') ");

            connTest ct = new connTest();
            DataSet ds = ct.Select(sb.ToString(), Global.Conn);

            DataTable dt = ds.Tables[0].Copy() ;
            


        }

    }
}
